package com.loyal.loyalerp.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectProvider;

import com.loyal.loyalerp.mapper.provider.EmployeeProvider;
import com.loyal.loyalerp.model.Employee;
@Mapper
public interface EmployeeMapper {
	@Select("select * from employee")
	List<Employee> listEmployee();

	@SelectProvider(type=EmployeeProvider.class,method="listEmployee")
	List<Employee> listSortedEmployee(String sidx,String sord);
	
	@SelectProvider(type=EmployeeProvider.class,method="findEmployee")
	List<Employee> findEmployee(String searchField, String searchString);
	
    int deleteByPrimaryKey(Long id);

    int insert(Employee record);

    int insertSelective(Employee record);

    Employee selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Employee record);

    int updateByPrimaryKeyWithBLOBs(Employee record);

    int updateByPrimaryKey(Employee record);
}